use inventory
GO
insert into Roles values('AM','ADMINISTRATOR')
insert into Roles values('SL','SALES')
insert into Roles values('SLM','SALES MANAGER')
insert into Roles values('IM','INVENTORY MANAGER')
GO
insert into Account values('Root','e10adc3949ba59abbe56e057f20f883e','admin','1/1/1988',1,'ha noi','123456789','admin@mail.com','AM',1,1)
GO
insert into Categories values('Vegetable',1)
insert into Categories values('Fruit',1)
insert into Categories values('Fast Food',1)
insert into Categories values('Fashion',1)
insert into Categories values('Tools',1)
insert into Categories values('Machine',1)
insert into Categories values('Electronic',1)
insert into Categories values('Intertaiment',1)
insert into Categories values('Technology',1)
insert into Categories values('Other',1)
GO
Insert Into Customers values ('Nguyen van A', 'Ha Noi','123456789','mail@gmail.com',1)
Insert Into Customers values ('Nguyen van B', 'Ha Noi','123456789','mail@gmail.com',1)
Insert Into Customers values ('Nguyen van C', 'Ha Noi','123456789','mail@gmail.com',1)
Insert Into Customers values ('Nguyen van D', 'Ha Noi','123456789','mail@gmail.com',1)
Insert Into Customers values ('Nguyen van E', 'Ha Noi','123456789','mail@gmail.com',1)
go
Insert into Items values (2,'Banana',100,12000,'KG','Banana','VN',1)
Insert into Items values (1,'potato',100,12000,'KG','Potati','VN',1)
Insert into Items values (2,'apple',100,12000,'KG','apple','VN',1)
Insert into Items values (2,'mango',100,12000,'KG','Mango','VN',1)
Insert into Items values (3,'Pizza',100,12000,'Pieces','Pizza','VN',1)
Insert into Items values (2,'cherry',100,12000,'KG','Cherry','VN',1)

